Programming with Python Project 2

Marketing Data Analysis

Domain

Marketing, Retail

Problem Statement

Q1 Import the necessary libraries and load the dataset and display 5 random samples.Check the info of the data and write your findings.

Inferences:

Q2 Check the following using an appropriate method and write your findings.

Inferences

Q3 Check for any missing values in the dataset and handle them using an appropriate method.

Missing value imputation

Q4 Check for any presence of special characters in any variables. If present, clean/replace and change the datatype of the variable if required.

Conclusion

Q5 The Marketing Manager wants to know the 'Age' of the customers. Extract the feature age from the given dataset and display the statistical summary of the age.

Conclusion

Q6 The Marketing manager wants to understand the total amount spent on various products so that we can find what percentage of the amount is spent on which product.

Q7 Being an Analyst understands the total number of purchases made through different channels which can help find the percentage these channels contribute.

Q8 The marketing manager wants to understand the performance of different marketing campaigns. Find out which marketing campaign is most successful? Use suitable graphs for visualization.

We can also analyze the success rate of the different campaigns them and arrange them accordingly.

Q9 The marketing manager wants to understand which products are performing the best and which are performing the least in terms of revenue. Being an analyst, analyse the data and plot a suitable graph to display a report on revenue generated by different products.

Q10 The team wants to understand if there’s any pattern between the age of customers and the last campaign acceptance rate. Plot a suitable graph to visualize the distribution of the age with respect to customers who accepted the last campaign.

Conclusion

Q11 The Chief Marketing specialist wants to visually see which Country has the most number of customers who accepted the last campaign. What is your approach?

Conclusion

Q12 Analyse visually and write your inferences about the relationship between the following.

Q13 Perform Correlation Analysis and write your key inferences

Inferences

Q14 Understand the Education background of the customers who complained in the last 2 years. State the Education background of the customers who have registered the most number of complaints.

Conclusion

Q15 .Use features 'Total_amount_spent', 'MntFruits', 'MntMeatProducts', 'MntFishProducts', 'MntSweetProducts' and, 'MntGoldProds' in x-axis and y-axis and plot the following plots.

Pairplot with hue as response to the last campaign

Pairplot with hue as Education levels

Pairplot with hue as Marital Status